UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0snzh7uCSP9M+zV9AUPHieeuReEiqgqYKGJQnAB18bk='
WHERE
key_id = 'b2de05438afc7b645b53e4d2578fa2e9898578f3178c8f327273c9ecdaf75ea8'
AND (
token = '0snzh7uCSP9M+zV9AUPHieeuReEiqgqYKGJQnAB18bk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)