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

Query time 0.00047