UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Ik2N+CZ38LuxU4qSLpAGFYF8tuQGT0dQHfo+SfqCdtU=' 
WHERE 
  key_id = '30ed43a9df5c6e9c7840927c7c5134198d9665433a85135e35cdb051d3b323df' 
  AND (
    token = 'Ik2N+CZ38LuxU4qSLpAGFYF8tuQGT0dQHfo+SfqCdtU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038