UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2fXJLUcoHzDjZTewEQPvcfmIYKxZIda89PSk291/IhE='
WHERE
key_id = '7a916dc4425fe8a5c6254ca9e2a8d4c6157ccaa092ea1c32ceb8b4b927eb7cb4'
AND (
token = '2fXJLUcoHzDjZTewEQPvcfmIYKxZIda89PSk291/IhE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)