UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nG5tOwKmz1xq8UOs1AK07IuAp/aHoEJH8u/RTEc2Dtg='
WHERE
key_id = '4c3570a1c0114d942ed860f728ecd2c02563472da40a9529f4e875ef0331478d'
AND (
token = 'nG5tOwKmz1xq8UOs1AK07IuAp/aHoEJH8u/RTEc2Dtg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)