UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KKty8hWBxSwVzNSskzWtOjD7HwqsAhYrAEITNZITxB8='
WHERE
key_id = '2430d6c9ce5bef230e4ca634a5aea2f3feb1d3f88e7d7999ff14ea09f74aa983'
AND (
token = 'KKty8hWBxSwVzNSskzWtOjD7HwqsAhYrAEITNZITxB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)