UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QjSAviycr6RdQrV87qjLsJ4pANrDZr7ffThLAxyJZgo='
WHERE
key_id = '12f00d356baf113d2f34abf3e95e058e95ecdbbf88689b74b4122b48aa30bbde'
AND (
token = 'QjSAviycr6RdQrV87qjLsJ4pANrDZr7ffThLAxyJZgo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)