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