UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B6tgXJaOBJIFPEbYJwmMVRElHw6CtuQyE6Pf+MXuXqU='
WHERE
key_id = 'a1b75e04be1f44e5f78e711ac9f7397ffbf8db68d550f0202d23ec9321ba65e3'
AND (
token = 'B6tgXJaOBJIFPEbYJwmMVRElHw6CtuQyE6Pf+MXuXqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)