UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TfGqY66zzWTHKdYI0sdunUZgFIx9y2wNUT9sYd6A9xc='
WHERE
key_id = 'e30a927c9cedd7ec8ecf206ad176ca49a5631ae3f4d32c0aa6dca573ac91abec'
AND (
token = 'TfGqY66zzWTHKdYI0sdunUZgFIx9y2wNUT9sYd6A9xc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)