UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LqZfOfOpifUtytulPAvqfIN8lTa1fMnJY0d7M50lSYs='
WHERE
key_id = '38e0ff49cb2faa69c9674390d3742c8e1af70184957010e866ecc9f74818c1c6'
AND (
token = 'LqZfOfOpifUtytulPAvqfIN8lTa1fMnJY0d7M50lSYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)