UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X49I0O1BWVOc1mkQAewSe3R7QSPva9yN9U8x/2N63v8='
WHERE
key_id = '21b3f88852df9462dd9408691ab0fd1d9b304333700405968b44adf0d249bb04'
AND (
token = 'X49I0O1BWVOc1mkQAewSe3R7QSPva9yN9U8x/2N63v8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)