UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'BuR/rT2C2rNezQOFM4T4vmPbe8LdFZ8MC6m77l8bDVs=' 
WHERE 
  key_id = '752e726cfa097b65c3c1728f51eea6bbe0471cf8bef555fb6d63e4dab6a319a7' 
  AND (
    token = 'BuR/rT2C2rNezQOFM4T4vmPbe8LdFZ8MC6m77l8bDVs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00049