UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7YJ72MLOsEN4lie73ijcJjII3e41vpmh05zuPHHWMrY='
WHERE
key_id = 'd805155a0d0d787200c8784e78705b5dcd3a7bad6785bc0a8c1b74c46b3cc69c'
AND (
token = '7YJ72MLOsEN4lie73ijcJjII3e41vpmh05zuPHHWMrY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)