UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZK4l011cpHcBJCyer5LGLf0YgLi0QwInYgIvbENaecU='
WHERE
key_id = 'e762bdba01fcea3af80867a4d2dfe035221c51ec241c5cda415b859a1c91545d'
AND (
token = 'ZK4l011cpHcBJCyer5LGLf0YgLi0QwInYgIvbENaecU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)