UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1jWzGageuYCm+h35wcYTqMtbEUp35uU3tXW0elTWwm8='
WHERE
key_id = 'f58f547e86abc8b5df7e6850c03e8015f6c40468997387a78a82919b7f9daa48'
AND (
token = '1jWzGageuYCm+h35wcYTqMtbEUp35uU3tXW0elTWwm8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)