UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r6fLoIf5SZqX0iNADs4UYNd1hJgBmmlAI4KvV+jiGGQ='
WHERE
key_id = '3cac765372620ec2baad965239a86c3e296a982cd00f382b97ca764b3c31840a'
AND (
token = 'r6fLoIf5SZqX0iNADs4UYNd1hJgBmmlAI4KvV+jiGGQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)