UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f5xF3a1JT/ZPI4qBpBwooBUJI/I/uqfib705DW7BJhg='
WHERE
key_id = 'e6967973070273e3e9b02eeb210355e27fff9ddd162bb628c508628d595e4b4d'
AND (
token = 'f5xF3a1JT/ZPI4qBpBwooBUJI/I/uqfib705DW7BJhg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)