UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o454RiQSVN7K0ukckBEzzT03wBuVI3yPtI+5m4JYlr0='
WHERE
key_id = 'f4ca6d27d37312eb8c37b1aefbd2e74cf19a46a2f32c20f9a4e205cea68c21a4'
AND (
token = 'o454RiQSVN7K0ukckBEzzT03wBuVI3yPtI+5m4JYlr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)