UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/fTBvYc+YyBsdPxPlaLIN0+USkcG4Jjo5zN56EZp9Tw='
WHERE
key_id = '6bce8184edbeb651a54636cfc5d5acdee7992c9d45903522446040a90f980bcb'
AND (
token = '/fTBvYc+YyBsdPxPlaLIN0+USkcG4Jjo5zN56EZp9Tw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)