UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Gai0ux16geZ8Pdx2S8UMQ+Ju9wMAwt8gQztLQJROk04=' 
WHERE 
  key_id = '5aafc97578dc4eb4ca74df57b61a92dabce4486c2e5b39a84c3aa63553fccec3' 
  AND (
    token = 'Gai0ux16geZ8Pdx2S8UMQ+Ju9wMAwt8gQztLQJROk04=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046