UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'J8ZYk0CZ4qMIB9z5JUfl6hYSdFttacEgtrfTK6gn4NQ=' 
WHERE 
  key_id = '8ad55fdd1aaefd39d9f36f42ef6b5e16933c553e7bab6c4a8a5f65f7ee6210ea' 
  AND (
    token = 'J8ZYk0CZ4qMIB9z5JUfl6hYSdFttacEgtrfTK6gn4NQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029