UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4Q4vlRld9G31psAeGC/CyFYcfYeYNf+OxG1Y+WgC+xY='
WHERE
key_id = 'eef0d606c9badb4746fc7f12153c9b71927174c3db2a6bf92afec5222f1233ae'
AND (
token = '4Q4vlRld9G31psAeGC/CyFYcfYeYNf+OxG1Y+WgC+xY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)