UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XU8+iL1A8tpSXUtMtpSRh0+0wQ54Tzw7Cfuhqd9JoSw='
WHERE
key_id = '1bc81fe9dd329d3973daf033e8ebdeb94385ef146ee6192867ed6d2a800061fa'
AND (
token = 'XU8+iL1A8tpSXUtMtpSRh0+0wQ54Tzw7Cfuhqd9JoSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)