UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tpn/xnqwqNZ5GkP9DTQ3gFfD5EDyi3D7grefxv4aB1Y='
WHERE
key_id = '7ffd80ca78454e3fde01261b3a9b1ad6be6de84b889f1513a3491ff058711dfd'
AND (
token = 'tpn/xnqwqNZ5GkP9DTQ3gFfD5EDyi3D7grefxv4aB1Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)