UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Ig9KpAkidT7iM1qug6n/AWrU4FjgcAqC8wscJNLgZA='
WHERE
key_id = 'b3cec292f61f87b4d24be04cb97b46c6561d9762fcb8c0279bd58d66781858d7'
AND (
token = '0Ig9KpAkidT7iM1qug6n/AWrU4FjgcAqC8wscJNLgZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)