UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GkVo313APpCiLeUwGEyScCraJ5XB9ZOnaaZlIxEz6KU='
WHERE
key_id = '8dd2074a2b70da9bc258b74e458e7c6527eadf277d64f7b541aac76756402ac6'
AND (
token = 'GkVo313APpCiLeUwGEyScCraJ5XB9ZOnaaZlIxEz6KU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)