UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G6VE5lt/g8xbz3nTPqS5ISVgZw7T2VWPxkFtTEA+PD8='
WHERE
key_id = 'c5742d36867b6966e26a7db74367e6ba5bae5896d5d73a567fc2f78d4d9b16ff'
AND (
token = 'G6VE5lt/g8xbz3nTPqS5ISVgZw7T2VWPxkFtTEA+PD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)