UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ER5ePuUYsZc5q8Qj64QD2wcutXx1E46y/6wzBWfPQoo='
WHERE
key_id = '9a4817119c204d46888c1702cb1cd69b55c90f8df5fd6608475b3257f94dbe10'
AND (
token = 'ER5ePuUYsZc5q8Qj64QD2wcutXx1E46y/6wzBWfPQoo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)