UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XuQwDDOqqLL6LIU1YnF0rHztSvkl7iIuMXf/B27L+6g='
WHERE
key_id = '7c9f2b0f171a3922c9756ed651f8469b6f895a23ce0b530daaeadcde6b3d2753'
AND (
token = 'XuQwDDOqqLL6LIU1YnF0rHztSvkl7iIuMXf/B27L+6g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)