UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '580Ohr96uJPAo/3AGWgsf8syLtlE0Fd9BzA0OQp5i88='
WHERE
key_id = 'd1caedc97d4792c5af6d71edde8c21f04b74b06391d0d880ab05cb5d4cb2947d'
AND (
token = '580Ohr96uJPAo/3AGWgsf8syLtlE0Fd9BzA0OQp5i88='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)