UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8V7djEMPZEpadfpXf8Ps+6P5gi6xNwpAq7KbnYlZPpM='
WHERE
key_id = 'b7662498a2b293c09b4bd79c6ca28db25c62ab8e6abe846047c9ef56149f3487'
AND (
token = '8V7djEMPZEpadfpXf8Ps+6P5gi6xNwpAq7KbnYlZPpM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)