UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oXWzuTGr7HGZ+C6HVdW+E8xkHxYjMhW/y1NLY+LU0Ak='
WHERE
key_id = 'eaf1c421f4b85fa0ad89e1544bf831640e066371aa3c319385caf88d31af509b'
AND (
token = 'oXWzuTGr7HGZ+C6HVdW+E8xkHxYjMhW/y1NLY+LU0Ak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)