UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5G/CL+jkFoWHeC8XH/MXp7Y2lgwva/qHP61zGpajMIw='
WHERE
key_id = '037ed67dda98f831b6ec727929481af9acb6978bb4ab8ee4573456575b83bc4e'
AND (
token = '5G/CL+jkFoWHeC8XH/MXp7Y2lgwva/qHP61zGpajMIw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)