UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'wwC9Sp9K0L7qzUVBKxZ5+mBwu9ZF+GMMECqV2AaP24c=' 
WHERE 
  key_id = 'e135eb55c3d13b199934e7855c65d2cd7078406b97dcf77e70ea7454a00e9dc6' 
  AND (
    token = 'wwC9Sp9K0L7qzUVBKxZ5+mBwu9ZF+GMMECqV2AaP24c=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031