UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i5BWbxJNLj+QOErnq5GgYgLSfHYV9TYO8z3TL2qkvm8='
WHERE
key_id = '9c9c8ca5c679f603fb75aed689c61d22d8ceaf2e46ed8ae86fd158557c261ef8'
AND (
token = 'i5BWbxJNLj+QOErnq5GgYgLSfHYV9TYO8z3TL2qkvm8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)